set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

--CREATEd:02/08/2010
--Author: nnamthach@gmail.com
ALTER procedure [dbo].[procAnswer_getall]
AS
BEGIN
SELECT     Answer.ID, Answer.Question_ID, Answer.Description, Answer.Explanation, Answer.IsRight, Answer.Order_Answer, Answer.Text_Answer, Answer.Enabled, 
                      Answer.ANAL_A0, Answer.ANAL_A1, Answer.ANAL_A2, Answer.ANAL_A3, Answer.ANAL_A4, Answer.ANAL_A5, Answer.ANAL_A6, Answer.ANAL_A7, Answer.ANAL_A8, 
                      Answer.ANAL_A9, Question.Description AS Des_Question, Question.Type
FROM         Answer INNER JOIN
                      Question ON Answer.Question_ID = Question.ID
END


